Pandas Profiling Report

Dataset statistics

Number of variables	39
Number of observations	1582
Missing cells	7203
Missing cells (%)	11.7%
Duplicate rows	94
Duplicate rows (%)	5.9%
Total size in memory	482.1 KiB
Average record size in memory	312.1 B

Variable types

DateTime	5
Numeric	7
Categorical	23
Unsupported	3
Boolean	1

Alerts

`LOB` has constant value "FMCG"	Constant
`BP TYPE` has constant value "RENTAL"	Constant
`Transfer Type` has constant value "Pallet CompanyOUT"	Constant
`PRODUCT CATEGORY` has constant value "Wooden Pallet"	Constant
`UNIT` has constant value "Nos"	Constant
`Document Type` has constant value "Allot"	Constant
`Detention` has constant value "0.0"	Constant
Dataset has 94 (5.9%) duplicate rows	Duplicates
`Customer/Vendor Name` has a high cardinality: 143 distinct values	High cardinality
`City` has a high cardinality: 62 distinct values	High cardinality
`TO WhsName` has a high cardinality: 143 distinct values	High cardinality
`SO ID` has a high cardinality: 424 distinct values	High cardinality
`Customer/Vendor Code` is highly correlated with `Region` and 7 other fields	High correlation
`To whsCode` is highly correlated with `Customer/Vendor Code` and 7 other fields	High correlation
`Region` is highly correlated with `Customer/Vendor Code` and 6 other fields	High correlation
`From WhsCode` is highly correlated with `Customer/Vendor Code` and 12 other fields	High correlation
`U_ActShipType` is highly correlated with `Customer/Vendor Code` and 3 other fields	High correlation
`ItemCode` is highly correlated with `Model TYPE` and 5 other fields	High correlation
`BP TYPE` is highly correlated with `Region` and 19 other fields	High correlation
`Detention` is highly correlated with `Region` and 19 other fields	High correlation
`U_SOTYPE` is highly correlated with `Model TYPE` and 4 other fields	High correlation
`U_AssetClass` is highly correlated with `ItemCode` and 2 other fields	High correlation
`UNIT` is highly correlated with `Region` and 19 other fields	High correlation
`LOB` is highly correlated with `Region` and 19 other fields	High correlation
`U_DocStatus` is highly correlated with `From WhsCode`	High correlation
`Direct Dispatch` is highly correlated with `From WhsCode` and 2 other fields	High correlation
`STATE` is highly correlated with `Customer/Vendor Code` and 7 other fields	High correlation
`From WhsName` is highly correlated with `Customer/Vendor Code` and 8 other fields	High correlation
`City` is highly correlated with `Customer/Vendor Code` and 9 other fields	High correlation
`Document Type` is highly correlated with `Region` and 19 other fields	High correlation
`Vehicle Type` is highly correlated with `Region` and 11 other fields	High correlation
`BP CATEGORY` is highly correlated with `Customer/Vendor Code` and 1 other fields	High correlation
`PRODUCT CATEGORY` is highly correlated with `Region` and 19 other fields	High correlation
`Transfer Type` is highly correlated with `Region` and 19 other fields	High correlation
`Model TYPE` is highly correlated with `ItemCode` and 3 other fields	High correlation
`QUANTITY` is highly correlated with `City` and 5 other fields	High correlation
`RATE` is highly correlated with `Model TYPE` and 4 other fields	High correlation
`U_GRNNO` is highly correlated with `City` and 1 other fields	High correlation
`Loading/Unloading` is highly correlated with `City` and 3 other fields	High correlation
`NumAtCard` has 1582 (100.0%) missing values	Missing
`Comments` has 1549 (97.9%) missing values	Missing
`U_GRNNO` has 861 (54.4%) missing values	Missing
`Loading/Unloading` has 487 (30.8%) missing values	Missing
`Detention` has 1138 (71.9%) missing values	Missing
`KITITEM` has 1582 (100.0%) missing values	Missing
`NumAtCard` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`Comments` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`KITITEM` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`U_Frt` has 281 (17.8%) zeros	Zeros
`Loading/Unloading` has 1065 (67.3%) zeros	Zeros

Reproduction

Analysis started	2023-04-30 17:17:52.591326
Analysis finished	2023-04-30 17:18:06.783848
Duration	14.19 seconds
Software version	pandas-profiling v3.3.0
Download configuration	config.json

POSTING DATE
Date

Distinct	479
Distinct (%)	30.3%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

Minimum	2019-12-06 00:00:00
Maximum	2022-11-26 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

EFFECTIVE DATE
Date

Distinct	472
Distinct (%)	29.8%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

Minimum	2019-12-06 00:00:00
Maximum	2022-11-26 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

CREATE DATE
Date

Distinct	479
Distinct (%)	30.3%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

Minimum	2019-12-06 00:00:00
Maximum	2022-11-26 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Customer/Vendor Code
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	143
Distinct (%)	9.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10004860.78

Minimum	10000408
Maximum	10008338
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.5 KiB

Quantile statistics

Minimum	10000408
5-th percentile	10001316
Q1	10002425
median	10006243
Q3	10006524
95-th percentile	10006966.9
Maximum	10008338
Range	7930
Interquartile range (IQR)	4099

Descriptive statistics

Standard deviation	2238.812447
Coefficient of variation (CV)	0.0002237724738
Kurtosis	-1.390454343
Mean	10004860.78
Median Absolute Deviation (MAD)	480
Skewness	-0.615446634
Sum	1.582768975 × 10¹⁰
Variance	5012281.171
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10002430	87	5.5%
10006243	67	4.2%
10006334	63	4.0%
10006453	51	3.2%
10002391	50	3.2%
10005871	48	3.0%
10001378	45	2.8%
10006335	42	2.7%
10002436	42	2.7%
10006678	39	2.5%
Other values (133)	1048	66.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10000408	8	0.5%
10000411	1	0.1%
10000413	2	0.1%
10000462	1	0.1%
10000740	7	0.4%
10001155	20	1.3%
10001216	29	1.8%
10001316	14	0.9%
10001317	4	0.3%
10001319	15	0.9%

Value	Count	Frequency (%)
10008338	1	0.1%
10008314	5	0.3%
10008112	1	0.1%
10008009	1	0.1%
10007944	2	0.1%
10007809	19	1.2%
10007735	2	0.1%
10007480	2	0.1%
10007353	6	0.4%
10007199	32	2.0%

Customer/Vendor Name
Categorical

HIGH CARDINALITY

Distinct	143
Distinct (%)	9.0%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

Cart Services Pvt. Ltd. _ Kolkata _Bagnan	87
Cart Services Pvt. Ltd. _ Coimbatore_ Selakarichal	67
Cart Services Private Limited_Rewari_Khijuri	63
Cart Services Private Limited_Bhiwandi_Saidham_G Whse_Unit 2	51
Cart Services Pvt. Ltd. _ Bangalore _Venkatapura Village Malur	50
Other values (138)	1264

Length

Max length	70
Median length	56
Mean length	45.63337547
Min length	28

Characters and Unicode

Total characters	72192
Distinct characters	62
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	43 ?
Unique (%)	2.7%

Sample

1st row	Cart Services Pvt. Ltd. _ Howrah _Uluberia ESR Warehousing
2nd row	Cart Services Pvt. Ltd. _ Howrah _Uluberia ESR Warehousing
3rd row	Cart Services Pvt Ltd _ Gurgoan _Embassy Industrial
4th row	Cart Services Pvt. Ltd. _ Gurgoan _ Tauru
5th row	Cart Services Pvt. Ltd. _ Gurgoan _ Tauru

Common Values

Value	Count	Frequency (%)
Cart Services Pvt. Ltd. _ Kolkata _Bagnan	87	5.5%
Cart Services Pvt. Ltd. _ Coimbatore_ Selakarichal	67	4.2%
Cart Services Private Limited_Rewari_Khijuri	63	4.0%
Cart Services Private Limited_Bhiwandi_Saidham_G Whse_Unit 2	51	3.2%
Cart Services Pvt. Ltd. _ Bangalore _Venkatapura Village Malur	50	3.2%
Cart Services Pvt. Ltd. _Hosur	48	3.0%
Cart Services Pvt. Ltd. _ Ludhiana	45	2.8%
Cart Services Private Limited_Thiruvallur_Orakkadu	42	2.7%
Cart Services Pvt. Ltd. _ Hosur _U2 BTS Large	42	2.7%
Cart Services Private Limited_Haringhata	39	2.5%
Other values (133)	1048	66.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
cart	1576	15.4%
services	1576	15.4%
	1174	11.4%
pvt	1069	10.4%
ltd	1017	9.9%
private	513	5.0%
limited	164	1.6%
bangalore	150	1.5%
bhiwandi	114	1.1%
hyderabad	96	0.9%
Other values (204)	2811	27.4%

Most occurring characters

Value	Count	Frequency (%)
	8826	12.2%
a	6543	9.1%
r	5490	7.6%
e	5489	7.6%
t	5430	7.5%
i	4870	6.7%
v	3298	4.6%
_	3110	4.3%
d	2563	3.6%
.	2056	2.8%
Other values (52)	24517	34.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	47282	65.5%
Uppercase Letter	10543	14.6%
Space Separator	8826	12.2%
Connector Punctuation	3110	4.3%
Other Punctuation	2071	2.9%
Decimal Number	360	0.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	6543	13.8%
r	5490	11.6%
e	5489	11.6%
t	5430	11.5%
i	4870	10.3%
v	3298	7.0%
d	2563	5.4%
s	1960	4.1%
c	1716	3.6%
n	1399	3.0%
Other values (15)	8524	18.0%

Uppercase Letter

Value	Count	Frequency (%)
S	1931	18.3%
C	1867	17.7%
L	1785	16.9%
P	1676	15.9%
B	614	5.8%
H	384	3.6%
K	255	2.4%
M	240	2.3%
G	210	2.0%
F	184	1.7%
Other values (15)	1397	13.3%

Decimal Number

Value	Count	Frequency (%)
2	170	47.2%
1	60	16.7%
8	34	9.4%
0	33	9.2%
3	26	7.2%
6	20	5.6%
4	14	3.9%
9	3	0.8%

Other Punctuation

Value	Count	Frequency (%)
.	2056	99.3%
,	15	0.7%

Space Separator

Value	Count	Frequency (%)
	8826	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	3110	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	57825	80.1%
Common	14367	19.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	6543	11.3%
r	5490	9.5%
e	5489	9.5%
t	5430	9.4%
i	4870	8.4%
v	3298	5.7%
d	2563	4.4%
s	1960	3.4%
S	1931	3.3%
C	1867	3.2%
Other values (40)	18384	31.8%

Common

Value	Count	Frequency (%)
	8826	61.4%
_	3110	21.6%
.	2056	14.3%
2	170	1.2%
1	60	0.4%
8	34	0.2%
0	33	0.2%
3	26	0.2%
6	20	0.1%
,	15	0.1%
Other values (2)	17	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	72192	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	8826	12.2%
a	6543	9.1%
r	5490	7.6%
e	5489	7.6%
t	5430	7.5%
i	4870	6.7%
v	3298	4.6%
_	3110	4.3%
d	2563	3.6%
.	2056	2.8%
Other values (52)	24517	34.0%

LOB
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

FMCG	1582

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	6328
Distinct characters	4
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FMCG
2nd row	FMCG
3rd row	FMCG
4th row	FMCG
5th row	FMCG

Common Values

Value	Count	Frequency (%)
FMCG	1582	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
fmcg	1582	100.0%

Most occurring characters

Value	Count	Frequency (%)
F	1582	25.0%
M	1582	25.0%
C	1582	25.0%
G	1582	25.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	6328	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
F	1582	25.0%
M	1582	25.0%
C	1582	25.0%
G	1582	25.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6328	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
F	1582	25.0%
M	1582	25.0%
C	1582	25.0%
G	1582	25.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6328	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
F	1582	25.0%
M	1582	25.0%
C	1582	25.0%
G	1582	25.0%

Region
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

South	618
North	361
East	305
West	298

Length

Max length	5
Median length	5
Mean length	4.618836915
Min length	4

Characters and Unicode

Total characters	7307
Distinct characters	12
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	East
2nd row	East
3rd row	North
4th row	North
5th row	North

Common Values

Value	Count	Frequency (%)
South	618	39.1%
North	361	22.8%
East	305	19.3%
West	298	18.8%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
south	618	39.1%
north	361	22.8%
east	305	19.3%
west	298	18.8%

Most occurring characters

Value	Count	Frequency (%)
t	1582	21.7%
o	979	13.4%
h	979	13.4%
S	618	8.5%
u	618	8.5%
s	603	8.3%
N	361	4.9%
r	361	4.9%
E	305	4.2%
a	305	4.2%
Other values (2)	596	8.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5725	78.3%
Uppercase Letter	1582	21.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	1582	27.6%
o	979	17.1%
h	979	17.1%
u	618	10.8%
s	603	10.5%
r	361	6.3%
a	305	5.3%
e	298	5.2%

Uppercase Letter

Value	Count	Frequency (%)
S	618	39.1%
N	361	22.8%
E	305	19.3%
W	298	18.8%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7307	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	1582	21.7%
o	979	13.4%
h	979	13.4%
S	618	8.5%
u	618	8.5%
s	603	8.3%
N	361	4.9%
r	361	4.9%
E	305	4.2%
a	305	4.2%
Other values (2)	596	8.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7307	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
t	1582	21.7%
o	979	13.4%
h	979	13.4%
S	618	8.5%
u	618	8.5%
s	603	8.3%
N	361	4.9%
r	361	4.9%
E	305	4.2%
a	305	4.2%
Other values (2)	596	8.2%

BP TYPE
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

RENTAL	1582

Length

Max length	6
Median length	6
Mean length	6
Min length	6

Characters and Unicode

Total characters	9492
Distinct characters	6
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RENTAL
2nd row	RENTAL
3rd row	RENTAL
4th row	RENTAL
5th row	RENTAL

Common Values

Value	Count	Frequency (%)
RENTAL	1582	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
rental	1582	100.0%

Most occurring characters

Value	Count	Frequency (%)
R	1582	16.7%
E	1582	16.7%
N	1582	16.7%
T	1582	16.7%
A	1582	16.7%
L	1582	16.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	9492	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	1582	16.7%
E	1582	16.7%
N	1582	16.7%
T	1582	16.7%
A	1582	16.7%
L	1582	16.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	9492	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	1582	16.7%
E	1582	16.7%
N	1582	16.7%
T	1582	16.7%
A	1582	16.7%
L	1582	16.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	9492	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	1582	16.7%
E	1582	16.7%
N	1582	16.7%
T	1582	16.7%
A	1582	16.7%
L	1582	16.7%

City
Categorical

HIGH CARDINALITY
HIGH CORRELATION

Distinct	62
Distinct (%)	3.9%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

Bangalore	159
Bhiwandi	111
Thane	102
Hyderabad	100
Kolkata	92
Other values (57)	1018

Length

Max length	13
Median length	11
Mean length	7.627054362
Min length	4

Characters and Unicode

Total characters	12066
Distinct characters	46
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	15 ?
Unique (%)	0.9%

Sample

1st row	Howrah
2nd row	Howrah
3rd row	Gurgaon
4th row	Gurgaon
5th row	Gurgaon

Common Values

Value	Count	Frequency (%)
Bangalore	159	10.1%
Bhiwandi	111	7.0%
Thane	102	6.4%
Hyderabad	100	6.3%
Kolkata	92	5.8%
Hosur	90	5.7%
Coimbatore	85	5.4%
Gurgaon	82	5.2%
Rewari	63	4.0%
Chennai	61	3.9%
Other values (52)	637	40.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
bangalore	159	10.0%
bhiwandi	111	7.0%
thane	102	6.4%
hyderabad	100	6.3%
kolkata	92	5.8%
hosur	90	5.7%
coimbatore	85	5.4%
gurgaon	82	5.2%
rewari	63	4.0%
chennai	61	3.8%
Other values (52)	640	40.4%

Most occurring characters

Value	Count	Frequency (%)
a	2200	18.2%
r	996	8.3%
n	864	7.2%
o	825	6.8%
i	733	6.1%
h	700	5.8%
e	630	5.2%
d	516	4.3%
u	454	3.8%
g	438	3.6%
Other values (36)	3710	30.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	10481	86.9%
Uppercase Letter	1582	13.1%
Space Separator	3	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	2200	21.0%
r	996	9.5%
n	864	8.2%
o	825	7.9%
i	733	7.0%
h	700	6.7%
e	630	6.0%
d	516	4.9%
u	454	4.3%
g	438	4.2%
Other values (14)	2125	20.3%

Uppercase Letter

Value	Count	Frequency (%)
H	300	19.0%
B	281	17.8%
C	147	9.3%
T	144	9.1%
G	118	7.5%
K	102	6.4%
D	70	4.4%
L	68	4.3%
R	67	4.2%
J	51	3.2%
Other values (11)	234	14.8%

Space Separator

Value	Count	Frequency (%)
	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	12063	> 99.9%
Common	3	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	2200	18.2%
r	996	8.3%
n	864	7.2%
o	825	6.8%
i	733	6.1%
h	700	5.8%
e	630	5.2%
d	516	4.3%
u	454	3.8%
g	438	3.6%
Other values (35)	3707	30.7%

Common

Value	Count	Frequency (%)
	3	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	12066	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	2200	18.2%
r	996	8.3%
n	864	7.2%
o	825	6.8%
i	733	6.1%
h	700	5.8%
e	630	5.2%
d	516	4.3%
u	454	3.8%
g	438	3.6%
Other values (36)	3710	30.7%

STATE
Categorical

HIGH CORRELATION

Distinct	18
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

Tamil Nadu	282
Maharashtra	257
Haryana	230
West Bengal	219
Karnataka	199
Other values (13)	395

Length

Max length	14
Median length	13
Mean length	9.415929204
Min length	5

Characters and Unicode

Total characters	14896
Distinct characters	34
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	West Bengal
2nd row	West Bengal
3rd row	Haryana
4th row	Haryana
5th row	Haryana

Common Values

Value	Count	Frequency (%)
Tamil Nadu	282	17.8%
Maharashtra	257	16.2%
Haryana	230	14.5%
West Bengal	219	13.8%
Karnataka	199	12.6%
Telangana	109	6.9%
Uttar Pradesh	68	4.3%
Punjab	56	3.5%
Bihar	45	2.8%
Gujarat	31	2.0%
Other values (8)	86	5.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
tamil	282	12.9%
nadu	282	12.9%
maharashtra	257	11.8%
haryana	230	10.5%
west	219	10.0%
bengal	219	10.0%
karnataka	199	9.1%
telangana	109	5.0%
pradesh	103	4.7%
uttar	68	3.1%
Other values (11)	218	10.0%

Most occurring characters

Value	Count	Frequency (%)
a	4061	27.3%
r	1223	8.2%
n	956	6.4%
t	852	5.7%
h	723	4.9%
s	655	4.4%
e	653	4.4%
l	613	4.1%
	604	4.1%
d	431	2.9%
Other values (24)	4125	27.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	12106	81.3%
Uppercase Letter	2186	14.7%
Space Separator	604	4.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	4061	33.5%
r	1223	10.1%
n	956	7.9%
t	852	7.0%
h	723	6.0%
s	655	5.4%
e	653	5.4%
l	613	5.1%
d	431	3.6%
u	369	3.0%
Other values (7)	1570	13.0%

Uppercase Letter

Value	Count	Frequency (%)
T	391	17.9%
N	282	12.9%
M	264	12.1%
B	264	12.1%
H	230	10.5%
W	219	10.0%
K	199	9.1%
P	159	7.3%
U	68	3.1%
A	58	2.7%
Other values (6)	52	2.4%

Space Separator

Value	Count	Frequency (%)
	604	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14292	95.9%
Common	604	4.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	4061	28.4%
r	1223	8.6%
n	956	6.7%
t	852	6.0%
h	723	5.1%
s	655	4.6%
e	653	4.6%
l	613	4.3%
d	431	3.0%
T	391	2.7%
Other values (23)	3734	26.1%

Common

Value	Count	Frequency (%)
	604	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14896	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	4061	27.3%
r	1223	8.2%
n	956	6.4%
t	852	5.7%
h	723	4.9%
s	655	4.4%
e	653	4.4%
l	613	4.1%
	604	4.1%
d	431	2.9%
Other values (24)	4125	27.7%

From WhsCode
Categorical

HIGH CORRELATION

Distinct	34
Distinct (%)	2.1%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

KA02	357
MH03	200
HY01	147
WB01	121
MH01	114
Other values (29)	643

Length

Max length	4
Median length	4
Mean length	4
Min length	4

Characters and Unicode

Total characters	6328
Distinct characters	26
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	0.1%

Sample

1st row	WB01
2nd row	WB01
3rd row	HY01
4th row	HY01
5th row	HY01

Common Values

Value	Count	Frequency (%)
KA02	357	22.6%
MH03	200	12.6%
HY01	147	9.3%
WB01	121	7.6%
MH01	114	7.2%
WB04	90	5.7%
TL02	73	4.6%
TN02	66	4.2%
HY02	59	3.7%
TL01	47	3.0%
Other values (24)	308	19.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ka02	357	22.6%
mh03	200	12.6%
hy01	147	9.3%
wb01	121	7.6%
mh01	114	7.2%
wb04	90	5.7%
tl02	73	4.6%
tn02	66	4.2%
hy02	59	3.7%
tl01	47	3.0%
Other values (24)	308	19.5%

Most occurring characters

Value	Count	Frequency (%)
0	1582	25.0%
2	629	9.9%
H	625	9.9%
1	502	7.9%
M	375	5.9%
A	372	5.9%
K	363	5.7%
Y	256	4.0%
T	238	3.8%
3	235	3.7%
Other values (16)	1151	18.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3164	50.0%
Uppercase Letter	3164	50.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
H	625	19.8%
M	375	11.9%
A	372	11.8%
K	363	11.5%
Y	256	8.1%
T	238	7.5%
B	225	7.1%
W	218	6.9%
L	120	3.8%
N	111	3.5%
Other values (7)	261	8.2%

Decimal Number

Value	Count	Frequency (%)
0	1582	50.0%
2	629	19.9%
1	502	15.9%
3	235	7.4%
4	103	3.3%
5	59	1.9%
8	41	1.3%
6	8	0.3%
7	5	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Common	3164	50.0%
Latin	3164	50.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
H	625	19.8%
M	375	11.9%
A	372	11.8%
K	363	11.5%
Y	256	8.1%
T	238	7.5%
B	225	7.1%
W	218	6.9%
L	120	3.8%
N	111	3.5%
Other values (7)	261	8.2%

Common

Value	Count	Frequency (%)
0	1582	50.0%
2	629	19.9%
1	502	15.9%
3	235	7.4%
4	103	3.3%
5	59	1.9%
8	41	1.3%
6	8	0.3%
7	5	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6328	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	1582	25.0%
2	629	9.9%
H	625	9.9%
1	502	7.9%
M	375	5.9%
A	372	5.9%
K	363	5.7%
Y	256	4.0%
T	238	3.8%
3	235	3.7%
Other values (16)	1151	18.2%

From WhsName
Categorical

HIGH CORRELATION

Distinct	23
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

Pallet Company India Bangalore-Hobli	357
Pallet Company India Kolkata	211
Pallet Company India Bhiwandi	205
Pallet Company India Pataudi	147
Pallet Company India Hyderabad	120
Other values (18)	542

Length

Max length	41
Median length	37
Mean length	29.96396966
Min length	23

Characters and Unicode

Total characters	47403
Distinct characters	39
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.1%

Sample

1st row	Pallet Company India Kolkata
2nd row	Pallet Company India Kolkata
3rd row	Pallet Company India Pataudi
4th row	Pallet Company India Pataudi
5th row	Pallet Company India Pataudi

Common Values

Value	Count	Frequency (%)
Pallet Company India Bangalore-Hobli	357	22.6%
Pallet Company India Kolkata	211	13.3%
Pallet Company India Bhiwandi	205	13.0%
Pallet Company India Pataudi	147	9.3%
Pallet Company India Hyderabad	120	7.6%
Pallet Company India HO	114	7.2%
Pallet Company India Chennai	111	7.0%
Pallet Company India Ambala	67	4.2%
Pallet Company India Lucknow	57	3.6%
Pallet Company India Nagpur	39	2.5%
Other values (13)	154	9.7%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
pallet	1582	24.8%
company	1582	24.8%
india	1582	24.8%
bangalore-hobli	357	5.6%
kolkata	211	3.3%
bhiwandi	205	3.2%
pataudi	183	2.9%
hyderabad	120	1.9%
ho	114	1.8%
chennai	111	1.7%
Other values (17)	340	5.3%

Most occurring characters

Value	Count	Frequency (%)
a	7212	15.2%
	4805	10.1%
l	4169	8.8%
n	4064	8.6%
i	2751	5.8%
o	2600	5.5%
d	2302	4.9%
e	2252	4.8%
t	1991	4.2%
P	1781	3.8%
Other values (29)	13476	28.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	35311	74.5%
Uppercase Letter	6888	14.5%
Space Separator	4805	10.1%
Dash Punctuation	370	0.8%
Other Punctuation	23	< 0.1%
Decimal Number	6	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	7212	20.4%
l	4169	11.8%
n	4064	11.5%
i	2751	7.8%
o	2600	7.4%
d	2302	6.5%
e	2252	6.4%
t	1991	5.6%
y	1702	4.8%
p	1672	4.7%
Other values (11)	4596	13.0%

Uppercase Letter

Value	Count	Frequency (%)
P	1781	25.9%
C	1693	24.6%
I	1589	23.1%
H	591	8.6%
B	580	8.4%
K	240	3.5%
O	114	1.7%
N	85	1.2%
G	68	1.0%
A	67	1.0%
Other values (4)	80	1.2%

Space Separator

Value	Count	Frequency (%)
	4805	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	370	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	23	100.0%

Decimal Number

Value	Count	Frequency (%)
1	6	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	42199	89.0%
Common	5204	11.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	7212	17.1%
l	4169	9.9%
n	4064	9.6%
i	2751	6.5%
o	2600	6.2%
d	2302	5.5%
e	2252	5.3%
t	1991	4.7%
P	1781	4.2%
y	1702	4.0%
Other values (25)	11375	27.0%

Common

Value	Count	Frequency (%)
	4805	92.3%
-	370	7.1%
.	23	0.4%
1	6	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	47403	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	7212	15.2%
	4805	10.1%
l	4169	8.8%
n	4064	8.6%
i	2751	5.8%
o	2600	5.5%
d	2302	4.9%
e	2252	4.8%
t	1991	4.2%
P	1781	3.8%
Other values (29)	13476	28.4%

To whsCode
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	143
Distinct (%)	9.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	10004860.78

Minimum	10000408
Maximum	10008338
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.5 KiB

Quantile statistics

Minimum	10000408
5-th percentile	10001316
Q1	10002425
median	10006243
Q3	10006524
95-th percentile	10006966.9
Maximum	10008338
Range	7930
Interquartile range (IQR)	4099

Descriptive statistics

Standard deviation	2238.812447
Coefficient of variation (CV)	0.0002237724738
Kurtosis	-1.390454343
Mean	10004860.78
Median Absolute Deviation (MAD)	480
Skewness	-0.615446634
Sum	1.582768975 × 10¹⁰
Variance	5012281.171
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
10002430	87	5.5%
10006243	67	4.2%
10006334	63	4.0%
10006453	51	3.2%
10002391	50	3.2%
10005871	48	3.0%
10001378	45	2.8%
10006335	42	2.7%
10002436	42	2.7%
10006678	39	2.5%
Other values (133)	1048	66.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
10000408	8	0.5%
10000411	1	0.1%
10000413	2	0.1%
10000462	1	0.1%
10000740	7	0.4%
10001155	20	1.3%
10001216	29	1.8%
10001316	14	0.9%
10001317	4	0.3%
10001319	15	0.9%

Value	Count	Frequency (%)
10008338	1	0.1%
10008314	5	0.3%
10008112	1	0.1%
10008009	1	0.1%
10007944	2	0.1%
10007809	19	1.2%
10007735	2	0.1%
10007480	2	0.1%
10007353	6	0.4%
10007199	32	2.0%

TO WhsName
Categorical

HIGH CARDINALITY

Distinct	143
Distinct (%)	9.0%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

Cart Services Pvt. Ltd. - Kolkata (Bagnan)	87
Cart Services Pvt. Ltd. _ Coimbatore_ Selakarichal	67
Cart Services Private Limited_Rewari_Khijuri	63
Cart Services Private Limited_Bhiwandi_Saidham_G Whse_Unit 2	51
Cart Services Pvt. Ltd. - Bangalore (Venkatapura Village, Malur )	50
Other values (138)	1264

Length

Max length	72
Median length	58
Mean length	45.88874842
Min length	28

Characters and Unicode

Total characters	72596
Distinct characters	66
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	43 ?
Unique (%)	2.7%

Sample

1st row	Cart Services Pvt. Ltd. - Howrah (Uluberia, ESR Warehousing)
2nd row	Cart Services Pvt. Ltd. - Howrah (Uluberia, ESR Warehousing)
3rd row	Cart Services Pvt. Ltd. - Gurgoan (Embassy Industrial)
4th row	Cart Services Pvt. Ltd. - Gurgoan ( Tauru)
5th row	Cart Services Pvt. Ltd. - Gurgoan ( Tauru)

Common Values

Value	Count	Frequency (%)
Cart Services Pvt. Ltd. - Kolkata (Bagnan)	87	5.5%
Cart Services Pvt. Ltd. _ Coimbatore_ Selakarichal	67	4.2%
Cart Services Private Limited_Rewari_Khijuri	63	4.0%
Cart Services Private Limited_Bhiwandi_Saidham_G Whse_Unit 2	51	3.2%
Cart Services Pvt. Ltd. - Bangalore (Venkatapura Village, Malur )	50	3.2%
Cart Services Pvt. Ltd. _Hosur	48	3.0%
Cart Services Pvt. Ltd. - Ludhiana	45	2.8%
Cart Services Private Limited_Thiruvallur_Orakkadu	42	2.7%
Cart Services Pvt. Ltd. - Hosur (U2 BTS Large)	42	2.7%
Cart Services Private Limited_Haringhata	39	2.5%
Other values (133)	1048	66.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
cart	1576	15.3%
services	1576	15.3%
	1224	11.9%
pvt	1069	10.4%
ltd	1017	9.9%
private	513	5.0%
limited	164	1.6%
bangalore	150	1.5%
bhiwandi	114	1.1%
hyderabad	96	0.9%
Other values (201)	2811	27.3%

Most occurring characters

Value	Count	Frequency (%)
	8780	12.1%
a	6533	9.0%
r	5483	7.6%
e	5476	7.5%
t	5424	7.5%
i	4863	6.7%
v	3298	4.5%
d	2556	3.5%
_	2136	2.9%
.	2074	2.9%
Other values (56)	25973	35.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	47199	65.0%
Uppercase Letter	10533	14.5%
Space Separator	8780	12.1%
Other Punctuation	2170	3.0%
Connector Punctuation	2136	2.9%
Dash Punctuation	521	0.7%
Open Punctuation	450	0.6%
Close Punctuation	450	0.6%
Decimal Number	357	0.5%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	6533	13.8%
r	5483	11.6%
e	5476	11.6%
t	5424	11.5%
i	4863	10.3%
v	3298	7.0%
d	2556	5.4%
s	1953	4.1%
c	1716	3.6%
n	1389	2.9%
Other values (15)	8508	18.0%

Uppercase Letter

Value	Count	Frequency (%)
S	1928	18.3%
C	1867	17.7%
L	1791	17.0%
P	1669	15.8%
B	621	5.9%
H	381	3.6%
K	255	2.4%
M	236	2.2%
G	210	2.0%
F	184	1.7%
Other values (15)	1391	13.2%

Decimal Number

Value	Count	Frequency (%)
2	170	47.6%
1	57	16.0%
8	34	9.5%
0	33	9.2%
3	26	7.3%
6	20	5.6%
4	14	3.9%
9	3	0.8%

Other Punctuation

Value	Count	Frequency (%)
.	2074	95.6%
,	93	4.3%
&	3	0.1%

Space Separator

Value	Count	Frequency (%)
	8780	100.0%

Connector Punctuation

Value	Count	Frequency (%)
_	2136	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	521	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	450	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	450	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	57732	79.5%
Common	14864	20.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	6533	11.3%
r	5483	9.5%
e	5476	9.5%
t	5424	9.4%
i	4863	8.4%
v	3298	5.7%
d	2556	4.4%
s	1953	3.4%
S	1928	3.3%
C	1867	3.2%
Other values (40)	18351	31.8%

Common

Value	Count	Frequency (%)
	8780	59.1%
_	2136	14.4%
.	2074	14.0%
-	521	3.5%
(	450	3.0%
)	450	3.0%
2	170	1.1%
,	93	0.6%
1	57	0.4%
8	34	0.2%
Other values (6)	99	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	72596	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	8780	12.1%
a	6533	9.0%
r	5483	7.6%
e	5476	7.5%
t	5424	7.5%
i	4863	6.7%
v	3298	4.5%
d	2556	3.5%
_	2136	2.9%
.	2074	2.9%
Other values (56)	25973	35.8%

Model TYPE
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

Allot	1560
Damage Swap	15
Trial	7

Length

Max length	11
Median length	5
Mean length	5.056890013
Min length	5

Characters and Unicode

Total characters	8000
Distinct characters	16
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Allot
2nd row	Allot
3rd row	Allot
4th row	Allot
5th row	Allot

Common Values

Value	Count	Frequency (%)
Allot	1560	98.6%
Damage Swap	15	0.9%
Trial	7	0.4%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
allot	1560	97.7%
damage	15	0.9%
swap	15	0.9%
trial	7	0.4%

Most occurring characters

Value	Count	Frequency (%)
l	3127	39.1%
A	1560	19.5%
o	1560	19.5%
t	1560	19.5%
a	52	0.7%
D	15	0.2%
m	15	0.2%
g	15	0.2%
e	15	0.2%
	15	0.2%
Other values (6)	66	0.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6388	79.8%
Uppercase Letter	1597	20.0%
Space Separator	15	0.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
l	3127	49.0%
o	1560	24.4%
t	1560	24.4%
a	52	0.8%
m	15	0.2%
g	15	0.2%
e	15	0.2%
w	15	0.2%
p	15	0.2%
r	7	0.1%

Uppercase Letter

Value	Count	Frequency (%)
A	1560	97.7%
D	15	0.9%
S	15	0.9%
T	7	0.4%

Space Separator

Value	Count	Frequency (%)
	15	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7985	99.8%
Common	15	0.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	3127	39.2%
A	1560	19.5%
o	1560	19.5%
t	1560	19.5%
a	52	0.7%
D	15	0.2%
m	15	0.2%
g	15	0.2%
e	15	0.2%
S	15	0.2%
Other values (5)	51	0.6%

Common

Value	Count	Frequency (%)
	15	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8000	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	3127	39.1%
A	1560	19.5%
o	1560	19.5%
t	1560	19.5%
a	52	0.7%
D	15	0.2%
m	15	0.2%
g	15	0.2%
e	15	0.2%
	15	0.2%
Other values (6)	66	0.8%

Transfer Type
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

Pallet CompanyOUT	1582

Length

Max length	17
Median length	17
Mean length	17
Min length	17

Characters and Unicode

Total characters	26894
Distinct characters	15
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Pallet CompanyOUT
2nd row	Pallet CompanyOUT
3rd row	Pallet CompanyOUT
4th row	Pallet CompanyOUT
5th row	Pallet CompanyOUT

Common Values

Value	Count	Frequency (%)
Pallet CompanyOUT	1582	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
pallet	1582	50.0%
companyout	1582	50.0%

Most occurring characters

Value	Count	Frequency (%)
a	3164	11.8%
l	3164	11.8%
P	1582	5.9%
e	1582	5.9%
t	1582	5.9%
	1582	5.9%
C	1582	5.9%
o	1582	5.9%
m	1582	5.9%
p	1582	5.9%
Other values (5)	7910	29.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	17402	64.7%
Uppercase Letter	7910	29.4%
Space Separator	1582	5.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	3164	18.2%
l	3164	18.2%
e	1582	9.1%
t	1582	9.1%
o	1582	9.1%
m	1582	9.1%
p	1582	9.1%
n	1582	9.1%
y	1582	9.1%

Uppercase Letter

Value	Count	Frequency (%)
P	1582	20.0%
C	1582	20.0%
O	1582	20.0%
U	1582	20.0%
T	1582	20.0%

Space Separator

Value	Count	Frequency (%)
	1582	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	25312	94.1%
Common	1582	5.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	3164	12.5%
l	3164	12.5%
P	1582	6.2%
e	1582	6.2%
t	1582	6.2%
C	1582	6.2%
o	1582	6.2%
m	1582	6.2%
p	1582	6.2%
n	1582	6.2%
Other values (4)	6328	25.0%

Common

Value	Count	Frequency (%)
	1582	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	26894	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	3164	11.8%
l	3164	11.8%
P	1582	5.9%
e	1582	5.9%
t	1582	5.9%
	1582	5.9%
C	1582	5.9%
o	1582	5.9%
m	1582	5.9%
p	1582	5.9%
Other values (5)	7910	29.4%

U_Frt
Real number (ℝ_≥0)

ZEROS

Distinct	52
Distinct (%)	3.3%
Missing	4
Missing (%)	0.3%
Infinite	0
Infinite (%)	0.0%
Mean	1816.297212

Minimum	0
Maximum	136000
Zeros	281
Zeros (%)	17.8%
Negative	0
Negative (%)	0.0%
Memory size	12.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	1
median	1
Q3	15
95-th percentile	10000
Maximum	136000
Range	136000
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	7623.607054
Coefficient of variation (CV)	4.197334558
Kurtosis	179.0526546
Mean	1816.297212
Median Absolute Deviation (MAD)	1
Skewness	11.81023856
Sum	2866117
Variance	58119384.52
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	599	37.9%
15	322	20.4%
0	281	17.8%
6	58	3.7%
10	41	2.6%
8500	36	2.3%
5000	24	1.5%
11500	23	1.5%
3500	22	1.4%
3000	16	1.0%
Other values (42)	156	9.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	281	17.8%
1	599	37.9%
2	1	0.1%
6	58	3.7%
8	1	0.1%
10	41	2.6%
15	322	20.4%
20	1	0.1%
1500	1	0.1%
2000	1	0.1%

Value	Count	Frequency (%)
136000	2	0.1%
120500	1	0.1%
95000	1	0.1%
62500	1	0.1%
53500	3	0.2%
50000	1	0.1%
39000	1	0.1%
25000	1	0.1%
21000	1	0.1%
18000	2	0.1%

U_ActShipType
Categorical

HIGH CORRELATION

Distinct	4
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

Pallet Company Transport borne by customer	1512
Customer Transport	46
Pallet Company Transport borne by Pallet Company	16
Vendor Transport	8

Length

Max length	48
Median length	42
Mean length	41.23135272
Min length	16

Characters and Unicode

Total characters	65228
Distinct characters	20
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Pallet Company Transport borne by customer
2nd row	Pallet Company Transport borne by customer
3rd row	Pallet Company Transport borne by customer
4th row	Pallet Company Transport borne by customer
5th row	Pallet Company Transport borne by customer

Common Values

Value	Count	Frequency (%)
Pallet Company Transport borne by customer	1512	95.6%
Customer Transport	46	2.9%
Pallet Company Transport borne by Pallet Company	16	1.0%
Vendor Transport	8	0.5%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
transport	1582	17.0%
customer	1558	16.8%
pallet	1544	16.6%
company	1544	16.6%
borne	1528	16.4%
by	1528	16.4%
vendor	8	0.1%

Most occurring characters

Value	Count	Frequency (%)
	7710	11.8%
r	6258	9.6%
o	6220	9.5%
t	4684	7.2%
a	4670	7.2%
n	4662	7.1%
e	4638	7.1%
s	3140	4.8%
p	3126	4.8%
m	3102	4.8%
Other values (10)	17018	26.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	52794	80.9%
Space Separator	7710	11.8%
Uppercase Letter	4724	7.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
r	6258	11.9%
o	6220	11.8%
t	4684	8.9%
a	4670	8.8%
n	4662	8.8%
e	4638	8.8%
s	3140	5.9%
p	3126	5.9%
m	3102	5.9%
l	3088	5.8%
Other values (5)	9206	17.4%

Uppercase Letter

Value	Count	Frequency (%)
C	1590	33.7%
T	1582	33.5%
P	1544	32.7%
V	8	0.2%

Space Separator

Value	Count	Frequency (%)
	7710	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	57518	88.2%
Common	7710	11.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
r	6258	10.9%
o	6220	10.8%
t	4684	8.1%
a	4670	8.1%
n	4662	8.1%
e	4638	8.1%
s	3140	5.5%
p	3126	5.4%
m	3102	5.4%
l	3088	5.4%
Other values (9)	13930	24.2%

Common

Value	Count	Frequency (%)
	7710	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	65228	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	7710	11.8%
r	6258	9.6%
o	6220	9.5%
t	4684	7.2%
a	4670	7.2%
n	4662	7.1%
e	4638	7.1%
s	3140	4.8%
p	3126	4.8%
m	3102	4.8%
Other values (10)	17018	26.1%

PRODUCT CATEGORY
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

Wooden Pallet	1582

Length

Max length	13
Median length	13
Mean length	13
Min length	13

Characters and Unicode

Total characters	20566
Distinct characters	10
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Wooden Pallet
2nd row	Wooden Pallet
3rd row	Wooden Pallet
4th row	Wooden Pallet
5th row	Wooden Pallet

Common Values

Value	Count	Frequency (%)
Wooden Pallet	1582	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
wooden	1582	50.0%
pallet	1582	50.0%

Most occurring characters

Value	Count	Frequency (%)
o	3164	15.4%
e	3164	15.4%
l	3164	15.4%
W	1582	7.7%
d	1582	7.7%
n	1582	7.7%
	1582	7.7%
P	1582	7.7%
a	1582	7.7%
t	1582	7.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	15820	76.9%
Uppercase Letter	3164	15.4%
Space Separator	1582	7.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	3164	20.0%
e	3164	20.0%
l	3164	20.0%
d	1582	10.0%
n	1582	10.0%
a	1582	10.0%
t	1582	10.0%

Uppercase Letter

Value	Count	Frequency (%)
W	1582	50.0%
P	1582	50.0%

Space Separator

Value	Count	Frequency (%)
	1582	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	18984	92.3%
Common	1582	7.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	3164	16.7%
e	3164	16.7%
l	3164	16.7%
W	1582	8.3%
d	1582	8.3%
n	1582	8.3%
P	1582	8.3%
a	1582	8.3%
t	1582	8.3%

Common

Value	Count	Frequency (%)
	1582	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20566	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	3164	15.4%
e	3164	15.4%
l	3164	15.4%
W	1582	7.7%
d	1582	7.7%
n	1582	7.7%
	1582	7.7%
P	1582	7.7%
a	1582	7.7%
t	1582	7.7%

ItemCode
Categorical

HIGH CORRELATION

Distinct	11
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

A010000023	1182
A010000038	121
A010000003	121
A010000104	111
A010000054	23
Other values (6)	24

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	15820
Distinct characters	10
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	0.2%

Sample

1st row	A010000023
2nd row	A010000023
3rd row	A010000054
4th row	A010000023
5th row	A010000023

Common Values

Value	Count	Frequency (%)
A010000023	1182	74.7%
A010000038	121	7.6%
A010000003	121	7.6%
A010000104	111	7.0%
A010000054	23	1.5%
A010000017	14	0.9%
A010000006	4	0.3%
A010000024	3	0.2%
A010000007	1	0.1%
A030000017	1	0.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
a010000023	1182	74.7%
a010000038	121	7.6%
a010000003	121	7.6%
a010000104	111	7.0%
a010000054	23	1.5%
a010000017	14	0.9%
a010000006	4	0.3%
a010000024	3	0.2%
a010000007	1	0.1%
a030000017	1	0.1%

Most occurring characters

Value	Count	Frequency (%)
0	9618	60.8%
1	1707	10.8%
A	1582	10.0%
3	1425	9.0%
2	1185	7.5%
4	137	0.9%
8	121	0.8%
5	24	0.2%
7	17	0.1%
6	4	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	14238	90.0%
Uppercase Letter	1582	10.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	9618	67.6%
1	1707	12.0%
3	1425	10.0%
2	1185	8.3%
4	137	1.0%
8	121	0.8%
5	24	0.2%
7	17	0.1%
6	4	< 0.1%

Uppercase Letter

Value	Count	Frequency (%)
A	1582	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	14238	90.0%
Latin	1582	10.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	9618	67.6%
1	1707	12.0%
3	1425	10.0%
2	1185	8.3%
4	137	1.0%
8	121	0.8%
5	24	0.2%
7	17	0.1%
6	4	< 0.1%

Latin

Value	Count	Frequency (%)
A	1582	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	15820	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	9618	60.8%
1	1707	10.8%
A	1582	10.0%
3	1425	9.0%
2	1185	7.5%
4	137	0.9%
8	121	0.8%
5	24	0.2%
7	17	0.1%
6	4	< 0.1%

QUANTITY
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	203
Distinct (%)	12.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	300.8482933

Minimum	1
Maximum	540
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.5 KiB

Quantile statistics

Minimum	1
5-th percentile	100
Q1	200
median	300
Q3	400
95-th percentile	500
Maximum	540
Range	539
Interquartile range (IQR)	200

Descriptive statistics

Standard deviation	127.7890161
Coefficient of variation (CV)	0.4247623102
Kurtosis	-0.8320066861
Mean	300.8482933
Median Absolute Deviation (MAD)	100
Skewness	-0.007435640738
Sum	475942
Variance	16330.03263
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
300	341	21.6%
200	153	9.7%
400	78	4.9%
230	73	4.6%
486	66	4.2%
500	65	4.1%
350	58	3.7%
180	56	3.5%
150	54	3.4%
450	46	2.9%
Other values (193)	592	37.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	5	0.3%
2	1	0.1%
5	1	0.1%
8	1	0.1%
10	1	0.1%
12	2	0.1%
14	1	0.1%
20	2	0.1%
25	1	0.1%
27	1	0.1%

Value	Count	Frequency (%)
540	1	0.1%
536	1	0.1%
528	1	0.1%
526	25	1.6%
520	2	0.1%
512	1	0.1%
507	1	0.1%
506	2	0.1%
501	2	0.1%
500	65	4.1%

UNIT
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

Nos	1582

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	4746
Distinct characters	3
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Nos
2nd row	Nos
3rd row	Nos
4th row	Nos
5th row	Nos

Common Values

Value	Count	Frequency (%)
Nos	1582	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
nos	1582	100.0%

Most occurring characters

Value	Count	Frequency (%)
N	1582	33.3%
o	1582	33.3%
s	1582	33.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3164	66.7%
Uppercase Letter	1582	33.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	1582	50.0%
s	1582	50.0%

Uppercase Letter

Value	Count	Frequency (%)
N	1582	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4746	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	1582	33.3%
o	1582	33.3%
s	1582	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4746	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	1582	33.3%
o	1582	33.3%
s	1582	33.3%

RATE
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	10
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2053.465234

Minimum	1200
Maximum	3375
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.5 KiB

Quantile statistics

Minimum	1200
5-th percentile	1500
Q1	1950
median	1950
Q3	1950
95-th percentile	2890
Maximum	3375
Range	2175
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	376.8625695
Coefficient of variation (CV)	0.1835251765
Kurtosis	1.000093339
Mean	2053.465234
Median Absolute Deviation (MAD)	0
Skewness	1.213583074
Sum	3248582
Variance	142025.3963
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
1950	1182	74.7%
1500	125	7.9%
2890	121	7.6%
2850	111	7.0%
2599	23	1.5%
1250	14	0.9%
2180	3	0.2%
1750	1	0.1%
3375	1	0.1%
1200	1	0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1200	1	0.1%
1250	14	0.9%
1500	125	7.9%
1750	1	0.1%
1950	1182	74.7%
2180	3	0.2%
2599	23	1.5%
2850	111	7.0%
2890	121	7.6%
3375	1	0.1%

Value	Count	Frequency (%)
3375	1	0.1%
2890	121	7.6%
2850	111	7.0%
2599	23	1.5%
2180	3	0.2%
1950	1182	74.7%
1750	1	0.1%
1500	125	7.9%
1250	14	0.9%
1200	1	0.1%

SO ID
Categorical

HIGH CARDINALITY

Distinct	424
Distinct (%)	26.8%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

2020/6995	45
2020/2306	34
2021/1802	33
2021/7167	26
2021/1433	26
Other values (419)	1418

Length

Max length	10
Median length	9
Mean length	8.994310999
Min length	8

Characters and Unicode

Total characters	14229
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	195 ?
Unique (%)	12.3%

Sample

1st row	2019/493
2nd row	2019/493
3rd row	2019/1133
4th row	2019/1309
5th row	2019/1309

Common Values

Value	Count	Frequency (%)
2020/6995	45	2.8%
2020/2306	34	2.1%
2021/1802	33	2.1%
2021/7167	26	1.6%
2021/1433	26	1.6%
2021/3159	25	1.6%
2021/2824	24	1.5%
2020/3523	23	1.5%
2021/2170	23	1.5%
2021/1804	23	1.5%
Other values (414)	1300	82.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2020/6995	45	2.8%
2020/2306	34	2.1%
2021/1802	33	2.1%
2021/7167	26	1.6%
2021/1433	26	1.6%
2021/3159	25	1.6%
2021/2824	24	1.5%
2020/3523	23	1.5%
2021/2170	23	1.5%
2021/1804	23	1.5%
Other values (414)	1300	82.2%

Most occurring characters

Value	Count	Frequency (%)
2	4287	30.1%
0	2772	19.5%
/	1582	11.1%
1	1298	9.1%
3	918	6.5%
9	786	5.5%
4	596	4.2%
6	538	3.8%
5	536	3.8%
8	486	3.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	12647	88.9%
Other Punctuation	1582	11.1%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
2	4287	33.9%
0	2772	21.9%
1	1298	10.3%
3	918	7.3%
9	786	6.2%
4	596	4.7%
6	538	4.3%
5	536	4.2%
8	486	3.8%
7	430	3.4%

Other Punctuation

Value	Count	Frequency (%)
/	1582	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	14229	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
2	4287	30.1%
0	2772	19.5%
/	1582	11.1%
1	1298	9.1%
3	918	6.5%
9	786	5.5%
4	596	4.2%
6	538	3.8%
5	536	3.8%
8	486	3.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14229	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
2	4287	30.1%
0	2772	19.5%
/	1582	11.1%
1	1298	9.1%
3	918	6.5%
9	786	5.5%
4	596	4.2%
6	538	3.8%
5	536	3.8%
8	486	3.4%

SO Creation Date
Date

Distinct	217
Distinct (%)	13.7%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

Minimum	2019-12-05 00:00:00
Maximum	2022-11-17 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

SO Due Date
Date

Distinct	229
Distinct (%)	14.5%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

Minimum	2019-12-05 00:00:00
Maximum	2022-11-21 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

U_DocStatus
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

C	1579
O	3

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	1582
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	C
2nd row	C
3rd row	C
4th row	C
5th row	C

Common Values

Value	Count	Frequency (%)
C	1579	99.8%
O	3	0.2%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
c	1579	99.8%
o	3	0.2%

Most occurring characters

Value	Count	Frequency (%)
C	1579	99.8%
O	3	0.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	1582	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	1579	99.8%
O	3	0.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	1582	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	1579	99.8%
O	3	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1582	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	1579	99.8%
O	3	0.2%

NumAtCard
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1582
Missing (%)	100.0%
Memory size	12.5 KiB

U_SOTYPE
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

Rent	1575
Trial	7

Length

Max length	5
Median length	4
Mean length	4.004424779
Min length	4

Characters and Unicode

Total characters	6335
Distinct characters	9
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Rent
2nd row	Rent
3rd row	Rent
4th row	Rent
5th row	Rent

Common Values

Value	Count	Frequency (%)
Rent	1575	99.6%
Trial	7	0.4%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
rent	1575	99.6%
trial	7	0.4%

Most occurring characters

Value	Count	Frequency (%)
R	1575	24.9%
e	1575	24.9%
n	1575	24.9%
t	1575	24.9%
T	7	0.1%
r	7	0.1%
i	7	0.1%
a	7	0.1%
l	7	0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	4753	75.0%
Uppercase Letter	1582	25.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	1575	33.1%
n	1575	33.1%
t	1575	33.1%
r	7	0.1%
i	7	0.1%
a	7	0.1%
l	7	0.1%

Uppercase Letter

Value	Count	Frequency (%)
R	1575	99.6%
T	7	0.4%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6335	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	1575	24.9%
e	1575	24.9%
n	1575	24.9%
t	1575	24.9%
T	7	0.1%
r	7	0.1%
i	7	0.1%
a	7	0.1%
l	7	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	6335	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	1575	24.9%
e	1575	24.9%
n	1575	24.9%
t	1575	24.9%
T	7	0.1%
r	7	0.1%
i	7	0.1%
a	7	0.1%
l	7	0.1%

BP CATEGORY
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

Ecommerce	1575
3PL	7

Length

Max length	9
Median length	9
Mean length	8.973451327
Min length	3

Characters and Unicode

Total characters	14196
Distinct characters	9
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Ecommerce
2nd row	Ecommerce
3rd row	Ecommerce
4th row	Ecommerce
5th row	Ecommerce

Common Values

Value	Count	Frequency (%)
Ecommerce	1575	99.6%
3PL	7	0.4%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
ecommerce	1575	99.6%
3pl	7	0.4%

Most occurring characters

Value	Count	Frequency (%)
c	3150	22.2%
m	3150	22.2%
e	3150	22.2%
E	1575	11.1%
o	1575	11.1%
r	1575	11.1%
3	7	< 0.1%
P	7	< 0.1%
L	7	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	12600	88.8%
Uppercase Letter	1589	11.2%
Decimal Number	7	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
c	3150	25.0%
m	3150	25.0%
e	3150	25.0%
o	1575	12.5%
r	1575	12.5%

Uppercase Letter

Value	Count	Frequency (%)
E	1575	99.1%
P	7	0.4%
L	7	0.4%

Decimal Number

Value	Count	Frequency (%)
3	7	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	14189	> 99.9%
Common	7	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
c	3150	22.2%
m	3150	22.2%
e	3150	22.2%
E	1575	11.1%
o	1575	11.1%
r	1575	11.1%
P	7	< 0.1%
L	7	< 0.1%

Common

Value	Count	Frequency (%)
3	7	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	14196	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
c	3150	22.2%
m	3150	22.2%
e	3150	22.2%
E	1575	11.1%
o	1575	11.1%
r	1575	11.1%
3	7	< 0.1%
P	7	< 0.1%
L	7	< 0.1%

Document Type
Categorical

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

Allot	1582

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	7910
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Allot
2nd row	Allot
3rd row	Allot
4th row	Allot
5th row	Allot

Common Values

Value	Count	Frequency (%)
Allot	1582	100.0%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
allot	1582	100.0%

Most occurring characters

Value	Count	Frequency (%)
l	3164	40.0%
A	1582	20.0%
o	1582	20.0%
t	1582	20.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	6328	80.0%
Uppercase Letter	1582	20.0%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
l	3164	50.0%
o	1582	25.0%
t	1582	25.0%

Uppercase Letter

Value	Count	Frequency (%)
A	1582	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	7910	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	3164	40.0%
A	1582	20.0%
o	1582	20.0%
t	1582	20.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7910	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	3164	40.0%
A	1582	20.0%
o	1582	20.0%
t	1582	20.0%

Vehicle Type
Categorical

HIGH CORRELATION

Distinct	16
Distinct (%)	1.0%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

32ft SXL	573
32ft MXL	271
40ft Open Trailer	238
19ft Vehicle	194
20ft Vehicle	142
Other values (11)	164

Length

Max length	22
Median length	8
Mean length	11.1795196
Min length	7

Characters and Unicode

Total characters	17686
Distinct characters	34
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	0.1%

Sample

1st row	19ft Vehicle
2nd row	19ft Part Load
3rd row	32ft SXL
4th row	19ft Vehicle
5th row	32ft SXL

Common Values

Value	Count	Frequency (%)
32ft SXL	573	36.2%
32ft MXL	271	17.1%
40ft Open Trailer	238	15.0%
19ft Vehicle	194	12.3%
20ft Vehicle	142	9.0%
40ft Container Trailer	92	5.8%
22ft Vehicle	20	1.3%
17ft Vehicle	17	1.1%
19ft Part Load	13	0.8%
Pick Up	5	0.3%
Other values (6)	17	1.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
32ft	844	24.1%
sxl	573	16.3%
vehicle	380	10.8%
40ft	330	9.4%
trailer	330	9.4%
mxl	271	7.7%
open	238	6.8%
19ft	207	5.9%
20ft	143	4.1%
container	92	2.6%
Other values (13)	101	2.9%

Most occurring characters

Value	Count	Frequency (%)
	1927	10.9%
t	1683	9.5%
f	1563	8.8%
e	1425	8.1%
2	1028	5.8%
L	858	4.9%
3	846	4.8%
X	844	4.8%
i	807	4.6%
r	766	4.3%
Other values (24)	5939	33.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	8982	50.8%
Uppercase Letter	3629	20.5%
Decimal Number	3148	17.8%
Space Separator	1927	10.9%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
t	1683	18.7%
f	1563	17.4%
e	1425	15.9%
i	807	9.0%
r	766	8.5%
l	710	7.9%
a	468	5.2%
n	422	4.7%
c	390	4.3%
h	380	4.2%
Other values (4)	368	4.1%

Uppercase Letter

Value	Count	Frequency (%)
L	858	23.6%
X	844	23.3%
S	573	15.8%
V	380	10.5%
T	339	9.3%
M	271	7.5%
O	238	6.6%
C	92	2.5%
P	19	0.5%
U	5	0.1%
Other values (2)	10	0.3%

Decimal Number

Value	Count	Frequency (%)
2	1028	32.7%
3	846	26.9%
0	477	15.2%
4	341	10.8%
1	228	7.2%
9	207	6.6%
7	21	0.7%

Space Separator

Value	Count	Frequency (%)
	1927	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	12611	71.3%
Common	5075	28.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
t	1683	13.3%
f	1563	12.4%
e	1425	11.3%
L	858	6.8%
X	844	6.7%
i	807	6.4%
r	766	6.1%
l	710	5.6%
S	573	4.5%
a	468	3.7%
Other values (16)	2914	23.1%

Common

Value	Count	Frequency (%)
	1927	38.0%
2	1028	20.3%
3	846	16.7%
0	477	9.4%
4	341	6.7%
1	228	4.5%
9	207	4.1%
7	21	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	17686	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	1927	10.9%
t	1683	9.5%
f	1563	8.8%
e	1425	8.1%
2	1028	5.8%
L	858	4.9%
3	846	4.8%
X	844	4.8%
i	807	4.6%
r	766	4.3%
Other values (24)	5939	33.6%

Direct Dispatch
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.7 KiB

False	880
True	702

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	880	55.6%
True	702	44.4%

Comments
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1549
Missing (%)	97.9%
Memory size	12.5 KiB

U_GRNNO
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	668
Distinct (%)	92.6%
Missing	861
Missing (%)	54.4%
Infinite	0
Infinite (%)	0.0%
Mean	1801.85853

Minimum	1
Maximum	12282
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	12.5 KiB

Quantile statistics

Minimum	1
5-th percentile	656
Q1	1138
median	1444
Q3	2102
95-th percentile	4541
Maximum	12282
Range	12281
Interquartile range (IQR)	964

Descriptive statistics

Standard deviation	1196.054914
Coefficient of variation (CV)	0.6637895786
Kurtosis	16.32012094
Mean	1801.85853
Median Absolute Deviation (MAD)	409
Skewness	2.909106213
Sum	1299140
Variance	1430547.358
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1235	3	0.2%
1584	2	0.1%
1103	2	0.1%
1225	2	0.1%
1655	2	0.1%
1686	2	0.1%
2742	2	0.1%
1168	2	0.1%
1	2	0.1%
1139	2	0.1%
Other values (658)	700	44.2%
(Missing)	861	54.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2	0.1%
4	1	0.1%
11	1	0.1%
32	1	0.1%
54	1	0.1%
63	1	0.1%
101	1	0.1%
142	1	0.1%
161	1	0.1%
163	2	0.1%

Value	Count	Frequency (%)
12282	1	0.1%
12175	1	0.1%
5111	1	0.1%
5054	1	0.1%
5053	1	0.1%
5028	1	0.1%
5026	1	0.1%
5015	1	0.1%
5011	1	0.1%
4980	1	0.1%

Loading/Unloading
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING
ZEROS

Distinct	6
Distinct (%)	0.5%
Missing	487
Missing (%)	30.8%
Infinite	0
Infinite (%)	0.0%
Mean	26.66940639

Minimum	0
Maximum	1800
Zeros	1065
Zeros (%)	67.3%
Negative	0
Negative (%)	0.0%
Memory size	12.5 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1800
Range	1800
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	171.7241749
Coefficient of variation (CV)	6.438995019
Kurtosis	43.84584797
Mean	26.66940639
Median Absolute Deviation (MAD)	0
Skewness	6.597955858
Sum	29203
Variance	29489.19225
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
0	1065	67.3%
1200	16	1.0%
800	9	0.6%
1	3	0.2%
1800	1	0.1%
1000	1	0.1%
(Missing)	487	30.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1065	67.3%
1	3	0.2%
800	9	0.6%
1000	1	0.1%
1200	16	1.0%
1800	1	0.1%

Value	Count	Frequency (%)
1800	1	0.1%
1200	16	1.0%
1000	1	0.1%
800	9	0.6%
1	3	0.2%
0	1065	67.3%

Detention
Categorical

CONSTANT
HIGH CORRELATION
MISSING
REJECTED

Distinct	1
Distinct (%)	0.2%
Missing	1138
Missing (%)	71.9%
Memory size	12.5 KiB

0.0	444

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	1332
Distinct characters	2
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0.0
2nd row	0.0
3rd row	0.0
4th row	0.0
5th row	0.0

Common Values

Value	Count	Frequency (%)
0.0	444	28.1%
(Missing)	1138	71.9%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
0.0	444	100.0%

Most occurring characters

Value	Count	Frequency (%)
0	888	66.7%
.	444	33.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	888	66.7%
Other Punctuation	444	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	888	100.0%

Other Punctuation

Value	Count	Frequency (%)
.	444	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1332	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	888	66.7%
.	444	33.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1332	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	888	66.7%
.	444	33.3%

KITITEM
Unsupported

MISSING
REJECTED
UNSUPPORTED

Missing	1582
Missing (%)	100.0%
Memory size	12.5 KiB

U_AssetClass
Categorical

HIGH CORRELATION

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	12.5 KiB

Wooden Pallet	1581
Wooden Pallet - SW	1

Length

Max length	18
Median length	13
Mean length	13.00316056
Min length	13

Characters and Unicode

Total characters	20571
Distinct characters	12
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.1%

Sample

1st row	Wooden Pallet
2nd row	Wooden Pallet
3rd row	Wooden Pallet
4th row	Wooden Pallet
5th row	Wooden Pallet

Common Values

Value	Count	Frequency (%)
Wooden Pallet	1581	99.9%
Wooden Pallet - SW	1	0.1%

Length

Histogram of lengths of the category

Category Frequency Plot

Value	Count	Frequency (%)
wooden	1582	50.0%
pallet	1582	50.0%
	1	< 0.1%
sw	1	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
o	3164	15.4%
e	3164	15.4%
l	3164	15.4%
	1584	7.7%
W	1583	7.7%
d	1582	7.7%
n	1582	7.7%
P	1582	7.7%
a	1582	7.7%
t	1582	7.7%
Other values (2)	2	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	15820	76.9%
Uppercase Letter	3166	15.4%
Space Separator	1584	7.7%
Dash Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	3164	20.0%
e	3164	20.0%
l	3164	20.0%
d	1582	10.0%
n	1582	10.0%
a	1582	10.0%
t	1582	10.0%

Uppercase Letter

Value	Count	Frequency (%)
W	1583	50.0%
P	1582	50.0%
S	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	1584	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	18986	92.3%
Common	1585	7.7%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	3164	16.7%
e	3164	16.7%
l	3164	16.7%
W	1583	8.3%
d	1582	8.3%
n	1582	8.3%
P	1582	8.3%
a	1582	8.3%
t	1582	8.3%
S	1	< 0.1%

Common

Value	Count	Frequency (%)
	1584	99.9%
-	1	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	20571	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	3164	15.4%
e	3164	15.4%
l	3164	15.4%
	1584	7.7%
W	1583	7.7%
d	1582	7.7%
n	1582	7.7%
P	1582	7.7%
a	1582	7.7%
t	1582	7.7%
Other values (2)	2	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	POSTING DATE	EFFECTIVE DATE	CREATE DATE	Customer/Vendor Code	Customer/Vendor Name	LOB	Region	BP TYPE	City	STATE	From WhsCode	From WhsName	To whsCode	TO WhsName	Model TYPE	Transfer Type	U_Frt	U_ActShipType	PRODUCT CATEGORY	ItemCode	QUANTITY	UNIT	RATE	SO ID	SO Creation Date	SO Due Date	U_DocStatus	NumAtCard	U_SOTYPE	BP CATEGORY	Document Type	Vehicle Type	Direct Dispatch	Comments	U_GRNNO	Loading/Unloading	Detention	KITITEM	U_AssetClass
0	2019-12-06	2019-12-06	2019-12-06	10002355	Cart Services Pvt. Ltd. _ Howrah _Uluberia ESR Warehousing	FMCG	East	RENTAL	Howrah	West Bengal	WB01	Pallet Company India Kolkata	10002355	Cart Services Pvt. Ltd. - Howrah (Uluberia, ESR Warehousing)	Allot	Pallet CompanyOUT	8500.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000023	200	Nos	1950	2019/493	2019-12-05	2019-12-05	C	NaN	Rent	Ecommerce	Allot	19ft Vehicle	N	191900083	NaN	800.0	NaN	NaN	Wooden Pallet
1	2019-12-06	2019-12-06	2019-12-06	10002355	Cart Services Pvt. Ltd. _ Howrah _Uluberia ESR Warehousing	FMCG	East	RENTAL	Howrah	West Bengal	WB01	Pallet Company India Kolkata	10002355	Cart Services Pvt. Ltd. - Howrah (Uluberia, ESR Warehousing)	Allot	Pallet CompanyOUT	8500.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000023	200	Nos	1950	2019/493	2019-12-05	2019-12-05	C	NaN	Rent	Ecommerce	Allot	19ft Part Load	N	191900082	NaN	800.0	NaN	NaN	Wooden Pallet
2	2019-12-20	2019-12-20	2019-12-20	10003155	Cart Services Pvt Ltd _ Gurgoan _Embassy Industrial	FMCG	North	RENTAL	Gurgaon	Haryana	HY01	Pallet Company India Pataudi	10003155	Cart Services Pvt. Ltd. - Gurgoan (Embassy Industrial)	Allot	Pallet CompanyOUT	4500.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000054	200	Nos	2599	2019/1133	2019-12-20	2019-12-27	C	NaN	Rent	Ecommerce	Allot	32ft SXL	N	61900469	NaN	0.0	NaN	NaN	Wooden Pallet
3	2019-12-26	2019-12-26	2019-12-26	10001155	Cart Services Pvt. Ltd. _ Gurgoan _ Tauru	FMCG	North	RENTAL	Gurgaon	Haryana	HY01	Pallet Company India Pataudi	10001155	Cart Services Pvt. Ltd. - Gurgoan ( Tauru)	Allot	Pallet CompanyOUT	3500.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000023	180	Nos	1950	2019/1309	2019-12-26	2020-01-02	C	NaN	Rent	Ecommerce	Allot	19ft Vehicle	N	61900477	NaN	0.0	NaN	NaN	Wooden Pallet
4	2019-12-26	2019-12-26	2019-12-26	10001155	Cart Services Pvt. Ltd. _ Gurgoan _ Tauru	FMCG	North	RENTAL	Gurgaon	Haryana	HY01	Pallet Company India Pataudi	10001155	Cart Services Pvt. Ltd. - Gurgoan ( Tauru)	Allot	Pallet CompanyOUT	4500.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000023	326	Nos	1950	2019/1309	2019-12-26	2020-01-02	C	NaN	Rent	Ecommerce	Allot	32ft SXL	N	61900478	NaN	0.0	NaN	NaN	Wooden Pallet
5	2019-12-28	2019-12-28	2019-12-28	10001155	Cart Services Pvt. Ltd. _ Gurgoan _ Tauru	FMCG	North	RENTAL	Gurgaon	Haryana	HY01	Pallet Company India Pataudi	10001155	Cart Services Pvt. Ltd. - Gurgoan ( Tauru)	Allot	Pallet CompanyOUT	0.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000023	494	Nos	1950	2019/1309	2019-12-26	2020-01-02	C	NaN	Rent	Ecommerce	Allot	32ft MXL	N	61900564	NaN	0.0	NaN	NaN	Wooden Pallet
6	2020-02-07	2020-02-07	2020-02-07	10001497	Cart Services Pvt. Ltd. _ Jhajjar _Flex Kulana FC	FMCG	North	RENTAL	Jhajjar	Haryana	KA02	Pallet Company India Bangalore-Hobli	10001497	Cart Services Pvt. Ltd. - Jhajjar (Flex Kulana FC)	Allot	Pallet CompanyOUT	53500.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000038	230	Nos	2890	2019/3204	2020-02-04	2020-02-10	C	NaN	Rent	Ecommerce	Allot	32ft MXL	N	291900912	NaN	0.0	NaN	NaN	Wooden Pallet
7	2020-02-07	2020-02-07	2020-02-07	10001497	Cart Services Pvt. Ltd. _ Jhajjar _Flex Kulana FC	FMCG	North	RENTAL	Jhajjar	Haryana	KA02	Pallet Company India Bangalore-Hobli	10001497	Cart Services Pvt. Ltd. - Jhajjar (Flex Kulana FC)	Allot	Pallet CompanyOUT	53500.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000038	230	Nos	2890	2019/3204	2020-02-04	2020-02-10	C	NaN	Rent	Ecommerce	Allot	32ft MXL	N	291900914	NaN	0.0	NaN	NaN	Wooden Pallet
8	2020-02-08	2020-02-08	2020-02-08	10001725	Cart Services Pvt. Ltd. _ Bhiwandi _WH B6and B8	FMCG	West	RENTAL	Bhiwandi	Maharashtra	MH03	Pallet Company India Bhiwandi	10001725	Cart Services Pvt. Ltd. - Bhiwandi (WH B6&B8)	Allot	Pallet CompanyOUT	4000.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000023	300	Nos	1950	2019/3450	2020-02-08	2020-02-09	C	NaN	Rent	Ecommerce	Allot	32ft SXL	N	271902158	NaN	NaN	NaN	NaN	Wooden Pallet
9	2020-02-17	2020-02-17	2020-02-17	10001497	Cart Services Pvt. Ltd. _ Jhajjar _Flex Kulana FC	FMCG	North	RENTAL	Jhajjar	Haryana	HY01	Pallet Company India Pataudi	10001497	Cart Services Pvt. Ltd. - Jhajjar (Flex Kulana FC)	Allot	Pallet CompanyOUT	62500.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000038	230	Nos	2890	2019/3204	2020-02-04	2020-02-10	C	NaN	Rent	Ecommerce	Allot	32ft MXL	Y	61901640	NaN	0.0	NaN	NaN	Wooden Pallet

Last rows

	POSTING DATE	EFFECTIVE DATE	CREATE DATE	Customer/Vendor Code	Customer/Vendor Name	LOB	Region	BP TYPE	City	STATE	From WhsCode	From WhsName	To whsCode	TO WhsName	Model TYPE	Transfer Type	U_Frt	U_ActShipType	PRODUCT CATEGORY	ItemCode	QUANTITY	UNIT	RATE	SO ID	SO Creation Date	SO Due Date	U_DocStatus	NumAtCard	U_SOTYPE	BP CATEGORY	Document Type	Vehicle Type	Direct Dispatch	Comments	U_GRNNO	Loading/Unloading	Detention	KITITEM	U_AssetClass
1572	2022-11-14	2022-11-14	2022-11-14	10001216	Cart Services Pvt. Ltd. _ Bangalore _Dasanapura	FMCG	South	RENTAL	Bangalore	Karnataka	TL02	Pallet Company India Hyderabad	10001216	Cart Services Pvt. Ltd. - Bangalore (Dasanapura)	Allot	Pallet CompanyOUT	1.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000017	200	Nos	1250	2022/5199	2022-10-29	2022-10-31	C	NaN	Rent	Ecommerce	Allot	32ft SXL	N	NaN	NaN	NaN	NaN	NaN	Wooden Pallet
1573	2022-11-17	2022-11-17	2022-11-17	10006335	Cart Services Private Limited_Thiruvallur_Orakkadu	FMCG	South	RENTAL	Tiruvallur	Tamil Nadu	TN02	Pallet Company India Chennai	10006335	Cart Services Private Limited_Thiruvallur_Orakkadu	Allot	Pallet CompanyOUT	0.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000017	170	Nos	1250	2022/5303	2022-11-02	2022-11-03	C	NaN	Rent	Ecommerce	Allot	20ft Vehicle	N	NaN	NaN	0.0	0.0	NaN	Wooden Pallet
1574	2022-11-18	2022-11-18	2022-11-18	10008314	Cart Services Private Limited_ Unnao_Hasanganj	FMCG	North	RENTAL	Unnao	Uttar Pradesh	MH01	Pallet Company India HO	10008314	Cart Services Private Limited_ Unnao_Hasanganj	Allot	Pallet CompanyOUT	15.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000023	450	Nos	1950	2022/5666	2022-11-17	2022-11-18	C	NaN	Rent	3PL	Allot	32ft MXL	Y	NaN	2731.0	0.0	0.0	NaN	Wooden Pallet
1575	2022-11-18	2022-11-18	2022-11-18	10001216	Cart Services Pvt. Ltd. _ Bangalore _Dasanapura	FMCG	South	RENTAL	Bangalore	Karnataka	TN02	Pallet Company India Chennai	10001216	Cart Services Pvt. Ltd. - Bangalore (Dasanapura)	Allot	Pallet CompanyOUT	0.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000017	100	Nos	1250	2022/5199	2022-10-29	2022-10-31	C	NaN	Rent	Ecommerce	Allot	17ft Vehicle	N	NaN	NaN	0.0	0.0	NaN	Wooden Pallet
1576	2022-11-19	2022-11-19	2022-11-19	10006335	Cart Services Private Limited_Thiruvallur_Orakkadu	FMCG	South	RENTAL	Tiruvallur	Tamil Nadu	TN02	Pallet Company India Chennai	10006335	Cart Services Private Limited_Thiruvallur_Orakkadu	Allot	Pallet CompanyOUT	0.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000017	180	Nos	1250	2022/5303	2022-11-02	2022-11-03	C	NaN	Rent	Ecommerce	Allot	20ft Vehicle	N	NaN	NaN	0.0	0.0	NaN	Wooden Pallet
1577	2022-11-19	2022-11-19	2022-11-19	10008314	Cart Services Private Limited_ Unnao_Hasanganj	FMCG	North	RENTAL	Unnao	Uttar Pradesh	MH01	Pallet Company India HO	10008314	Cart Services Private Limited_ Unnao_Hasanganj	Allot	Pallet CompanyOUT	15.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000023	500	Nos	1950	2022/5666	2022-11-17	2022-11-18	C	NaN	Rent	3PL	Allot	32ft MXL	Y	NaN	2742.0	0.0	0.0	NaN	Wooden Pallet
1578	2022-11-21	2022-11-21	2022-11-21	10008314	Cart Services Private Limited_ Unnao_Hasanganj	FMCG	North	RENTAL	Unnao	Uttar Pradesh	MH01	Pallet Company India HO	10008314	Cart Services Private Limited_ Unnao_Hasanganj	Allot	Pallet CompanyOUT	15.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000023	490	Nos	1950	2022/5666	2022-11-17	2022-11-18	O	NaN	Rent	3PL	Allot	32ft MXL	Y	NaN	2758.0	NaN	NaN	NaN	Wooden Pallet
1579	2022-11-22	2022-11-22	2022-11-22	10006814	Cart Services Pvt. Ltd. _ Bhiwandi_CF	FMCG	West	RENTAL	Thane	Maharashtra	MH07	Pallet Company India Bhiwandi	10006814	Cart Services Pvt. Ltd. _ Bhiwandi_CF	Allot	Pallet CompanyOUT	6.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000017	200	Nos	1250	2022/5595	2022-11-14	2022-11-17	C	NaN	Rent	Ecommerce	Allot	20ft Vehicle	N	NaN	NaN	NaN	NaN	NaN	Wooden Pallet
1580	2022-11-26	2022-11-26	2022-11-26	10006524	Cart Services Pvt. Ltd. _ Hyderabad _Pudur	FMCG	South	RENTAL	Hyderabad	Telangana	MH07	Pallet Company India Bhiwandi	10006524	Cart Services Pvt. Ltd. _ Hyderabad _Pudur	Allot	Pallet CompanyOUT	1.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000017	200	Nos	1250	2022/5650	2022-11-17	2022-11-21	O	NaN	Rent	Ecommerce	Allot	32ft SXL	N	NaN	NaN	NaN	NaN	NaN	Wooden Pallet
1581	2022-11-26	2022-11-26	2022-11-26	10008338	Cart Services Private Limited_Hyderabad_Medchal_Pudur	FMCG	South	RENTAL	Hyderabad	Telangana	MH07	Pallet Company India Bhiwandi	10008338	Cart Services Private Limited_Hyderabad_Medchal_Pudur	Allot	Pallet CompanyOUT	1.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000017	200	Nos	1250	2022/5612	2022-11-15	2022-11-17	O	NaN	Rent	Ecommerce	Allot	32ft SXL	N	NaN	NaN	NaN	NaN	NaN	Wooden Pallet

Most frequently occurring

	POSTING DATE	EFFECTIVE DATE	CREATE DATE	Customer/Vendor Code	Customer/Vendor Name	LOB	Region	BP TYPE	City	STATE	From WhsCode	From WhsName	To whsCode	TO WhsName	Model TYPE	Transfer Type	U_Frt	U_ActShipType	PRODUCT CATEGORY	ItemCode	QUANTITY	UNIT	RATE	SO ID	SO Creation Date	SO Due Date	U_DocStatus	U_SOTYPE	BP CATEGORY	Document Type	Vehicle Type	Direct Dispatch	U_GRNNO	Loading/Unloading	Detention	U_AssetClass	# duplicates
72	2021-12-29	2021-12-29	2021-12-29	10007199	Cart Services Private Limited_Dharwad FC	FMCG	South	RENTAL	Dharwad	Karnataka	KA02	Pallet Company India Bangalore-Hobli	10007199	Cart Services Private Limited_Dharwad FC	Allot	Pallet CompanyOUT	1.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000023	300	Nos	1950	2021/7167	2021-12-23	2021-12-24	C	Rent	Ecommerce	Allot	32ft SXL	N	NaN	NaN	NaN	Wooden Pallet	6
19	2020-09-05	2020-09-05	2020-09-05	10003155	Cart Services Pvt Ltd _ Gurgoan _Embassy Industrial	FMCG	North	RENTAL	Gurgaon	Haryana	MH03	Pallet Company India Bhiwandi	10003155	Cart Services Pvt. Ltd. - Gurgoan (Embassy Industrial)	Allot	Pallet CompanyOUT	6.0	Customer Transport	Wooden Pallet	A010000038	107	Nos	2890	2020/3368	2020-09-05	2020-09-07	C	Rent	Ecommerce	Allot	32ft SXL	N	NaN	NaN	NaN	Wooden Pallet	5
40	2021-01-04	2021-01-04	2021-01-04	10006243	Cart Services Pvt. Ltd. _ Coimbatore_ Selakarichal	FMCG	South	RENTAL	Coimbatore	Tamil Nadu	KA02	Pallet Company India Bangalore-Hobli	10006243	Cart Services Pvt. Ltd. _ Coimbatore_ Selakarichal	Allot	Pallet CompanyOUT	15.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000023	350	Nos	1950	2020/6995	2020-12-08	2021-01-02	C	Rent	Ecommerce	Allot	32ft MXL	N	NaN	0.0	NaN	Wooden Pallet	5
69	2021-12-25	2021-12-25	2021-12-25	10007199	Cart Services Private Limited_Dharwad FC	FMCG	South	RENTAL	Dharwad	Karnataka	KA02	Pallet Company India Bangalore-Hobli	10007199	Cart Services Private Limited_Dharwad FC	Allot	Pallet CompanyOUT	1.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000023	322	Nos	1950	2021/7167	2021-12-23	2021-12-24	C	Rent	Ecommerce	Allot	32ft SXL	N	NaN	NaN	NaN	Wooden Pallet	5
17	2020-09-05	2020-09-05	2020-09-05	10001497	Cart Services Pvt. Ltd. _ Jhajjar _Flex Kulana FC	FMCG	North	RENTAL	Jhajjar	Haryana	MH03	Pallet Company India Bhiwandi	10001497	Cart Services Pvt. Ltd. - Jhajjar (Flex Kulana FC)	Allot	Pallet CompanyOUT	6.0	Customer Transport	Wooden Pallet	A010000038	105	Nos	2890	2020/3334	2020-09-04	2020-09-05	C	Rent	Ecommerce	Allot	32ft SXL	N	NaN	NaN	NaN	Wooden Pallet	4
70	2021-12-27	2021-12-27	2021-12-27	10007199	Cart Services Private Limited_Dharwad FC	FMCG	South	RENTAL	Dharwad	Karnataka	KA02	Pallet Company India Bangalore-Hobli	10007199	Cart Services Private Limited_Dharwad FC	Allot	Pallet CompanyOUT	1.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000023	322	Nos	1950	2021/7167	2021-12-23	2021-12-24	C	Rent	Ecommerce	Allot	32ft SXL	N	NaN	NaN	NaN	Wooden Pallet	4
71	2021-12-28	2021-12-28	2021-12-28	10007199	Cart Services Private Limited_Dharwad FC	FMCG	South	RENTAL	Dharwad	Karnataka	KA02	Pallet Company India Bangalore-Hobli	10007199	Cart Services Private Limited_Dharwad FC	Allot	Pallet CompanyOUT	1.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000023	300	Nos	1950	2021/7167	2021-12-23	2021-12-24	C	Rent	Ecommerce	Allot	32ft SXL	N	NaN	NaN	NaN	Wooden Pallet	4
73	2021-12-30	2021-12-30	2021-12-30	10007199	Cart Services Private Limited_Dharwad FC	FMCG	South	RENTAL	Dharwad	Karnataka	KA02	Pallet Company India Bangalore-Hobli	10007199	Cart Services Private Limited_Dharwad FC	Allot	Pallet CompanyOUT	1.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000023	300	Nos	1950	2021/7167	2021-12-23	2021-12-24	C	Rent	Ecommerce	Allot	32ft SXL	N	NaN	NaN	NaN	Wooden Pallet	4
1	2020-07-30	2020-07-30	2020-07-30	10002391	Cart Services Pvt. Ltd. _ Bangalore _Venkatapura Village Malur	FMCG	South	RENTAL	Bangalore	Karnataka	KA02	Pallet Company India Bangalore-Hobli	10002391	Cart Services Pvt. Ltd. - Bangalore (Venkatapura Village, Malur )	Allot	Pallet CompanyOUT	12000.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000003	300	Nos	1500	2020/1987	2020-07-30	2020-07-31	C	Rent	Ecommerce	Allot	32ft SXL	N	NaN	0.0	NaN	Wooden Pallet	3
10	2020-08-10	2020-08-10	2020-08-10	10005874	Cart Services Private Limited _ Bhiwandi_ Saidham, G Warehouse	FMCG	West	RENTAL	Thane	Maharashtra	MH03	Pallet Company India Bhiwandi	10005874	Cart Services Private Limited _ Bhiwandi_ Saidham, G Warehouse	Allot	Pallet CompanyOUT	5000.0	Pallet Company Transport borne by customer	Wooden Pallet	A010000003	300	Nos	1500	2020/2294	2020-08-07	2020-08-21	C	Rent	Ecommerce	Allot	32ft SXL	N	NaN	NaN	NaN	Wooden Pallet	3

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Connector Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Category Frequency Plot

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category